KPI % 12
In this step we are going to continue to create 4 KPI percentages:-

DAX calculation for Mortality rate

 Mortality Rate = CALCULATE(DIVIDE([Total Deaths],[Total Cases],0),'COVID-19 In US'[date])+0


Steps for this report

Go to our report page to work on our card for Mortality Rate %.

1. Drag and drop card from visualization.

2. Drag and drop Mortality rate % measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.  Boarder - on




Calculated Columns:
_Last Week Total Case = 
 Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
 Return
 CALCULATE(MAX('COVID-19 In US'[positive Increase]) , 
           FILTER('COVID-19 In US' ,
                  'COVID-19 In US'[date] = __Last Week
           ))+0
_Last Week Total Deaths = 
 Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
 Return
 CALCULATE(MAX('COVID-19 In US'[death Increase]) , 
           FILTER('COVID-19 In US', 
                  'COVID-19 In US'[date] = __Last Week 
            
            ))+0

DAX calculation for Death WOW% :  

           Death WoW% = 
           VAR __Previous Week = 
           DIVIDE(MAX('COVID-19 In US'[_Last Week Total Deaths]),MAX('COVID-19 In US'[_Last Week Total Case]),0)
           Return
           DIVIDE(([Mortality Rate]- __Previous Week),__PreviousWeek,0)+0


Conditional Formatting:

          Death WOW% Sign = SWITCH(TRUE(),'Measure'[Death WoW%]>0,UNICHAR(9650),
                              [Death WoW%]<0,UNICHAR(9660),UNICHAR(9644))&ROUND([Death WoW%],1)&"%"             
          Death WOW% Color = IF([Death WoW%]>0,"#fa8264","#1c9407")



Steps for this report

Go to our report page to work on our card for  Death WOW %.

1. Drag and drop card from visualization.

2. Drag and drop Death WOW% sign measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.   Boarder - on




DAX calculation for Infection Rate%:

               Infection Rate = CALCULATE(DIVIDE([Total Cases],[Total Infection],0),'COVID-19 In US'[date])+0
        Total Infection = SUM('COVID-19 in US'[total Test Results Increase])



Steps for this report

Go to our report page to work on our card for Infection Rate %.

1. Drag and drop card from visualization.

2. Drag and drop Infection rate % measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.   Boarder - on


DAX calculation for Infection WOW% :  

                Infection WoW% = 
            VAR __Previous Week = 
            DIVIDE(MAX('COVID-19 In US'[_Last Week Total Case]),MAX('COVID-19 In US'[_Last Week Total Test]),0)
            Return
            DIVIDE(([Infection Rate]- __Previous Week),__PreviousWeek,0)+0


Calculated Columns:

_Last Week Total Test = 
 Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
 Return
 CALCULATE(MAX('COVID-19 In US'[total Test Results Increase]) , 
          FILTER('COVID-19 In US', 
                 'COVID-19 In US'[date] = __Last Week 
                 ))+0


Conditional Formatting:

        Infection WOW% sign = SWITCH(TRUE(),'Measure'[Infection WoW%]>0,UNICHAR(9650),
                             [Infection WoW%] <0,UNICHAR(9660),UNICHAR(9644))&ROUND([Infection WoW%],1)&"%"
          Infection WOW% Color = IF([Infection WoW%]>0,"#fa8264","#1c9407")


Steps for this report

Go to our report page to work on our card for Infection WOW %.

1. Drag and drop card from visualization.

2. Drag and drop Infection WOW% sign measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.  Boarder - on



DAX time intelligence explained:
(https://exceleratorbi.com.au/dax-time-intelligence-beginners/)

How to add YOY, WOW, QOQ, MOM analysis in power Bi?
(https://www.youtube.com/watch?v=UnbmjegqALc)